var mongoose = require('mongoose');
var Say = require('../models/say.model')// 引数据模型

// 新增
exports.create = function(req,res,next){
    var say = new Say(req.body); // 从req.body里获取参数对象，比如{title:'vane',gender:'男',city:'杭州'....}
    //user是表
    say.save()
    .then(data=>{
        res.json(data)
    })
    
}

exports.get = function(req,res,next){
    var id=req.params.id;
    Say.findById(id,function(err,result){
    	res.json(result)
    })
}


//修改
exports.update = function(req,res,next){
  
    var id = req.params.id; // req.param('id')
    // 现在操作的都是mongoose而不是mongodb
    Say.findByIdAndUpdate(id,{$set: req.body}, {new:false} )
    .then(data=>{
        res.json({msg:'数据修改成功',status:200}); // 如果你要返回数据，这个data返回的是你之前修改的那个数据内容
    })
}

//删除
exports.remove = function(req,res,next){
    var id = req.params.id;
    Say.findByIdAndRemove(id,function(err,doc){
        res.json({msg:'数据删除成功',status:200})
    })
} 


exports.list = function(req,res,next){
    var page = (req.body.page) ? req.body.page : 1;
    var limit = (req.body.limit) ? req.body.limit : 2;
    // var rows = (req.body.limit) ? req.body.rows : 2;

    var queryCondition = {};
    var title;
    if( req.body.title && req.body.title.trim().length>0 ){
        title = req.body.title;
        queryCondition = {"title":new RegExp(title,'i')}
    }
    if(req.body.cateId && req.body.cateId.trim().length>0){
        cateId=req.body.cateId;
        queryCondition={
            "cateId":cateId
        }
    }

    // User.paginate(queryCondition, { page: page, limit:parseInt(rows)}, function(err, result) {
    Say.paginate(queryCondition, { page: page, limit: limit }, function(err, result) {
        result.rows = result.docs;
        delete result.docs;
       res.json(result)
    });
}
exports.all = function(req,res,next){
    Say.find({},function(err,data){
        res.json(data);
    })
}